order ruler: date/self/thumbup_num
Brightcells
1 changed files with 1 additions and 1 deletions
+ 1
- 1
utils/sql/raw.py
@@ -10,6 +10,6 @@ PAI2_HOME_API = ( |
||
| 10 | 10 |
r"left outer join group_groupinfo as T2 on T1.group_id = T2.group_id " |
| 11 | 11 |
r"left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id " |
| 12 | 12 |
r"where T3.status = 1 " |
| 13 |
- r"order by FIELD(T3.user_id, '{user_id}') desc, DATE(T3.created_at) desc, T3.thumbup_num desc "
|
|
| 13 |
+ r"order by DATE(T3.created_at) desc, FIELD(T3.user_id, '{user_id}') desc, T3.thumbup_num desc "
|
|
| 14 | 14 |
r"limit {offset}, {rows};"
|
| 15 | 15 |
) |